CREATE TABLE [dbo].[Referral]
(
[REFERRAL_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_REFERRAL_ID] DEFAULT (''),
[CLIENT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_CLIENT_ID] DEFAULT (''),
[PROVIDER_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_PROVIDER_ID] DEFAULT (''),
[IS_REFERRAL] [bit] NOT NULL CONSTRAINT [DF_Referral_IS_REFERRAL] DEFAULT ((0)),
[NO_SHOW] [bit] NOT NULL CONSTRAINT [DF_Referral_NO_SHOW] DEFAULT ((0)),
[REFERRAL_FEE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Referral_REFERRAL_FEE] DEFAULT ((0)),
[ORDER_NUMBER] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Referral_ORDER_NUMBER] DEFAULT ((0)),
[READY_TO_INVOICE] [bit] NOT NULL CONSTRAINT [DF_Referral_READY_TO_INVOICE] DEFAULT ((0)),
[ZIP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_ZIP] DEFAULT (''),
[SEARCH_1] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_SEARCH_1] DEFAULT (''),
[SEARCH_2] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_SEARCH_2] DEFAULT (''),
[SEARCH_3] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_SEARCH_3] DEFAULT (''),
[SEARCH_4] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_SEARCH_4] DEFAULT (''),
[SEARCH_5] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_SEARCH_5] DEFAULT (''),
[SEARCH_6] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_SEARCH_6] DEFAULT (''),
[GEN_TABLE_1_CHOICE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_GEN_TABLE_1_CHOICE] DEFAULT (''),
[GEN_TABLE_2_CHOICE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_GEN_TABLE_2_CHOICE] DEFAULT (''),
[GEN_TABLE_3_CHOICE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_GEN_TABLE_3_CHOICE] DEFAULT (''),
[GEN_TABLE_4_CHOICE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_GEN_TABLE_4_CHOICE] DEFAULT (''),
[UPDATED_BY] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Referral_UPDATED_BY] DEFAULT (''),
[DATE_CREATED] [datetime] NULL,
[DATE_UPDATED] [datetime] NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Referral] ADD CONSTRAINT [PK_Referral] PRIMARY KEY CLUSTERED ([REFERRAL_ID], [CLIENT_ID], [PROVIDER_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReferralCLIENT_ID] ON [dbo].[Referral] ([CLIENT_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReferralDATE_CREATED] ON [dbo].[Referral] ([DATE_CREATED]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReferralGEN_TAB_1] ON [dbo].[Referral] ([GEN_TABLE_1_CHOICE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReferralGEN_TAB_2] ON [dbo].[Referral] ([GEN_TABLE_2_CHOICE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReferralGEN_TAB_3] ON [dbo].[Referral] ([GEN_TABLE_3_CHOICE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReferralGEN_TAB_4] ON [dbo].[Referral] ([GEN_TABLE_4_CHOICE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReferralPROVIDER_ID] ON [dbo].[Referral] ([PROVIDER_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iReferralZIP] ON [dbo].[Referral] ([ZIP]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Referral] TO [IMIS]
GRANT SELECT ON  [dbo].[Referral] TO [IMIS]
GRANT INSERT ON  [dbo].[Referral] TO [IMIS]
GRANT DELETE ON  [dbo].[Referral] TO [IMIS]
GRANT UPDATE ON  [dbo].[Referral] TO [IMIS]
GO